package com.meetflow.web.controller.common;

import java.io.FileInputStream;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.alibaba.fastjson2.JSONObject;
import com.meetflow.system.service.ISysConfigService;
import jcifs.smb.NtlmPasswordAuthentication;
import jcifs.smb.SmbFile;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.MediaType;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;
import com.meetflow.common.config.RuoYiConfig;
import com.meetflow.common.constant.Constants;
import com.meetflow.common.core.domain.AjaxResult;
import com.meetflow.common.utils.StringUtils;
import com.meetflow.common.utils.file.FileUploadUtils;
import com.meetflow.common.utils.file.FileUtils;
import com.meetflow.framework.config.ServerConfig;

import static com.meetflow.common.core.domain.AjaxResult.success;

/**
 * 通用请求处理
 * 
 * @author ruoyi
 */
@RestController
@RequestMapping("/common")
public class CommonController
{
    private static final Logger log = LoggerFactory.getLogger(CommonController.class);

    @Autowired
    private ServerConfig serverConfig;

    @Autowired
    private ISysConfigService configService;

    private static final String FILE_DELIMETER = ",";

    /**
     * 通用下载请求
     * 
     * @param fileName 文件名称
     * @param delete 是否删除
     */
    @GetMapping("/download")
    public void fileDownload(String fileName, Boolean delete, HttpServletResponse response, HttpServletRequest request)
    {
        try
        {
            if (!FileUtils.checkAllowDownload(fileName))
            {
                throw new Exception(StringUtils.format("文件名称({})非法，不允许下载。 ", fileName));
            }
            String realFileName = System.currentTimeMillis() + fileName.substring(fileName.indexOf("_") + 1);
            String filePath = RuoYiConfig.getDownloadPath() + fileName;

            response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
            FileUtils.setAttachmentResponseHeader(response, realFileName);
            FileUtils.writeBytes(filePath, response.getOutputStream());
            if (delete)
            {
                FileUtils.deleteFile(filePath);
            }
        }
        catch (Exception e)
        {
            log.error("下载文件失败", e);
        }
    }

    /**
     * 通用上传请求（单个）
     */
    @PostMapping("/upload")
    public AjaxResult uploadFile(MultipartFile file) throws Exception
    {
        try
        {
            // 上传文件路径
            String filePath = RuoYiConfig.getUploadPath();
            // 上传并返回新文件名称
            String fileName = FileUploadUtils.upload(filePath, file);
            String url = serverConfig.getUrl() + fileName;
            AjaxResult ajax = success();
            ajax.put("url", url);
            ajax.put("fileName", fileName);
            ajax.put("newFileName", FileUtils.getName(fileName));
            ajax.put("originalFilename", file.getOriginalFilename());
            return ajax;
        }
        catch (Exception e)
        {
            return AjaxResult.error(e.getMessage());
        }
    }

    /**
     * 通用上传请求（多个）
     */
    @PostMapping("/uploads")
    public AjaxResult uploadFiles(List<MultipartFile> files) throws Exception
    {
        try
        {
            // 上传文件路径
            String filePath = RuoYiConfig.getUploadPath();
            List<String> urls = new ArrayList<String>();
            List<String> fileNames = new ArrayList<String>();
            List<String> newFileNames = new ArrayList<String>();
            List<String> originalFilenames = new ArrayList<String>();
            for (MultipartFile file : files)
            {
                // 上传并返回新文件名称
                String fileName = FileUploadUtils.upload(filePath, file);
                String url = serverConfig.getUrl() + fileName;
                urls.add(url);
                fileNames.add(fileName);
                newFileNames.add(FileUtils.getName(fileName));
                originalFilenames.add(file.getOriginalFilename());
            }
            AjaxResult ajax = success();
            ajax.put("urls", StringUtils.join(urls, FILE_DELIMETER));
            ajax.put("fileNames", StringUtils.join(fileNames, FILE_DELIMETER));
            ajax.put("newFileNames", StringUtils.join(newFileNames, FILE_DELIMETER));
            ajax.put("originalFilenames", StringUtils.join(originalFilenames, FILE_DELIMETER));
            return ajax;
        }
        catch (Exception e)
        {
            return AjaxResult.error(e.getMessage());
        }
    }

    @GetMapping(value = "/getStatisticRecord")
    public AjaxResult getStatisticRecord() {
        String domain = configService.selectConfigByKey("sys.meet.smb.domain");
        String userName  = configService.selectConfigByKey("sys.meet.smb.account");
        String password = configService.selectConfigByKey("sys.meet.smb.password");
        JSONObject result = new JSONObject();
        String title1 = configService.selectConfigByKey("sys.meet.smb.title1");
        String url1 = configService.selectConfigByKey("sys.meet.smb.url1");
        Map<String,List<String>> KPI1 = getFileData(domain,userName,password,url1);
        result.put("KPI1",KPI1);
        result.put("KPI1TITLE",title1);
        String title2 = configService.selectConfigByKey("sys.meet.smb.title2");
        String url2 = configService.selectConfigByKey("sys.meet.smb.url2");
        Map<String,List<String>> KPI2 = getFileData(domain,userName,password,url2);
        result.put("KPI2",KPI2);
        result.put("KPI2TITLE",title2);
        String title3 = configService.selectConfigByKey("sys.meet.smb.title3");
        String url3 = configService.selectConfigByKey("sys.meet.smb.url3");
        Map<String,List<String>> KPI3 = getFileData(domain,userName,password,url3);
        result.put("KPI3",KPI3);
        result.put("KPI3TITLE",title3);
        return success(result);
    }

    private Map<String,List<String>> getFileData(String domain, String userName, String password, String url){
        log.info("domain={}，userName={}，password={},url={}",domain,userName,password,url);
        NtlmPasswordAuthentication auth = new NtlmPasswordAuthentication(domain, userName, password);
        Map<String,List<String>> result = new HashMap<>();
        try {
            SmbFile smbFile = new SmbFile(url, auth);
            Workbook workbook = new XSSFWorkbook(smbFile.getInputStream());
//            FileInputStream file = new FileInputStream("C:/work/1交期达成率.xlsx");
//            Workbook workbook = new XSSFWorkbook(file);
            workbook.setForceFormulaRecalculation(false);
            Sheet sheet = workbook.getSheet("KPI");
            FormulaEvaluator formulaEvaluator = workbook.getCreationHelper().createFormulaEvaluator();
            Row firstRow = sheet.getRow(1);
            List<String> title = new ArrayList<>();
            log.info("读取excelROW={}",firstRow.getFirstCellNum() + 6);
            for (int i = firstRow.getFirstCellNum() + 6; i < 18; i++) {
                title.add(firstRow.getCell(i).getStringCellValue());
            }
            result.put("xAxis", title);
            Row lastRow = sheet.getRow(3);
            log.info("读取excel-data={}",lastRow.getCell(lastRow.getFirstCellNum()+5).getStringCellValue());
            List<String> data = new ArrayList<>();
            for (int i = lastRow.getFirstCellNum()+6; i < 18; i++) {
                Cell cell = lastRow.getCell(i);
                BigDecimal value = new BigDecimal(0);
                switch (cell.getCellType()) {
                    case STRING:
                        value = new BigDecimal(cell.getStringCellValue()).multiply(new BigDecimal(100)).setScale(1,BigDecimal.ROUND_HALF_UP);
                        data.add(value.toPlainString());
                        break;
                    case NUMERIC:
                        value = new BigDecimal(cell.getNumericCellValue()).multiply(new BigDecimal(100)).setScale(1,BigDecimal.ROUND_HALF_UP);
                        data.add(value.toPlainString());
                        break;
                    case FORMULA:
                        CellValue cellValue = formulaEvaluator.evaluate(cell);
                        value = new BigDecimal(cellValue.getNumberValue()).multiply(new BigDecimal(100)).setScale(1,BigDecimal.ROUND_HALF_UP);
                        data.add(value.toPlainString());
                        break;
                    default:
                        data.add(StringUtils.EMPTY);
                        break;
                }
            }
            result.put("yAxis", data);
            workbook.close();
        } catch (Exception e) {
            log.error("读取execl文件失败",e);
            e.printStackTrace();
        }
        return result;
    }

    /**
     * 本地资源通用下载
     */
    @GetMapping("/download/resource")
    public void resourceDownload(String resource, HttpServletRequest request, HttpServletResponse response)
            throws Exception
    {
        try
        {
            if (!FileUtils.checkAllowDownload(resource))
            {
                throw new Exception(StringUtils.format("资源文件({})非法，不允许下载。 ", resource));
            }
            // 本地资源路径
            String localPath = RuoYiConfig.getProfile();
            // 数据库资源地址
            String downloadPath = localPath + StringUtils.substringAfter(resource, Constants.RESOURCE_PREFIX);
            // 下载名称
            String downloadName = StringUtils.substringAfterLast(downloadPath, "/");
            response.setContentType(MediaType.APPLICATION_OCTET_STREAM_VALUE);
            FileUtils.setAttachmentResponseHeader(response, downloadName);
            FileUtils.writeBytes(downloadPath, response.getOutputStream());
        }
        catch (Exception e)
        {
            log.error("下载文件失败", e);
        }
    }
}
